例文:The other way to handle this is to use an array formula . . . with that you would evaluate the conditionals you want and include it in a sum if it met the conditional.